﻿
<?php
	require('db.php');
?>
<table width="768" align="center" border = "1">
<tr bgcolor="#EFEFEF">
<td>当前Context(Case)表内容
</td>
</tr>
</table>
<table width="768" align="center" border = "1">
<tr>
	<td>PID</td>
	<td>SID</td>
	<td>VID</td>
	<td>CID</td>
	<td>Context</td>
</tr>
<?php
	$sql = "select * from context order by cid";
	$data = mysql_query($sql, $conn);
	while ($arr = mysql_fetch_array($data))
	{
		echo '<tr><td>'.$arr[pid].'</td><td>'.$arr[sid].'</td><td>'.$arr[vid].'</td><td bgcolor=red>'.$arr[cid].'</td><td>'.$arr[context].'</td></tr>';
	}
?>
</table>

<table width="768" align="center" border = "1">
<tr bgcolor="#EFEFEF">
<td>当前Properties表内容
</td>
</tr>
</table>
<table width="768" align="center" border = "1">
<tr>
	<td>PID</td>
	<td>Properties</td>
</tr>
<?php
	$sql = "select * from properties order by pid";
	$data = mysql_query($sql, $conn);
	while ($arr = mysql_fetch_array($data))
	{
		echo '<tr><td bgcolor = red>'.$arr[pid].'</td><td>'.$arr[pro].'</td></tr>';
	}
?>
</table>
<table width="768" align="center" border = "1">
<tr bgcolor="#EFEFEF">
<td>当前SubProperties表内容
</td>
</tr>
</table>
<table width="768" align="center" border = "1">
<tr>
	<td>PID</td>
	<td>SID</td>
	<td>SubPro</td>
</tr>
<?php
	$sql = "select * from subpro order by sid";
	$data = mysql_query($sql, $conn);
	while ($arr = mysql_fetch_array($data))
	{
		echo '<tr><td>'.$arr[pid].'</td><td bgcolor=red>'.$arr[sid].'</td><td>'.$arr[subPro].'</td></tr>';
	}
?>
</table>
<table width="768" align="center" border = "1">
<tr bgcolor="#EFEFEF">
<td>当前Version表内容
</td>
</tr>
</table>
<table width="768" align="center" border = "1">
<tr>
	<td>VID</td>
	<td>Version</td>
</tr>
<?php
	$sql = "select * from version order by vid";
	$data = mysql_query($sql, $conn);
	while ($arr = mysql_fetch_array($data))
	{
		echo '<tr><td bgcolor=red>'.$arr[vid].'</td><td>'.$arr[version].'</td></tr>';
	}
	mysql_close($conn);
?>
</table>
